package com.hnhs.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CategoryProductMapper {
    //查询类目总条数
    @Select("select COUNT(*) FROM 202_category")
    public int categoryCount();
    //今日新增数量
    @Select("select count(*) from 202_category where DATE(lastUpdateTime) = CURDATE()")
    public int categoryTodayCount();
    //查询商品总条数
    @Select("select COUNT(*) FROM 202_product")
    public int productCount();
    @Select("select count(*) from 202_product where DATE(lastUpdateTime) = CURDATE()")
    public int productTodayCount();
}
